/*
 *  Copyright (C) 2011 Hatsites <Hatsites_AT_gmail.com>
 *
 *  This program is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU General Public License
 *  as published by the Free Software Foundation; either version 2
 *  of the License, or (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 */

package org.myorg.ctm.etk.dtb.structure.dtb.tbl;

import org.myorg.shr.dtb.structure.db.table.TblAbs;
import org.myorg.shr.dtb.structure.dtb.tbl.fld.*;

/**
 *
 * @author Hatsites
 *
 * email: Hatsites_AT_gmail.com
 * ... please remove "_AT_" from the above string to get the right email address
 *
 */

public class TblClt extends TblAbs{

    private TblClt(){
        super("client");
        super.add(STR_ID,               FldTypVarChar.s_getInstance(), 20, _strId_);
        super.add(STR_IDT_NOM,          FldTypVarChar.s_getInstance(), 20, _strIdentiteNom_);
        super.add(STR_IDT_PRENOM1,      FldTypVarChar.s_getInstance(), 20, _strIdentitePrenom1_);
        super.add(STR_IDT_PRENOM2,      FldTypVarChar.s_getInstance(), 20, _strIdentitePrenom2_);
        super.add(STR_IDT_PRENOM3,      FldTypVarChar.s_getInstance(), 20, _strIdentitePrenom3_);
        super.add(STR_IDT_SEXE,         FldTypChar.s_getInstance(), 1, _strIdentiteSexe_);
        super.add(STR_IDT_BIRTH,        FldTypDate.s_getInstance(), 20, _strIdentiteDateNaissance_);
        super.add(STR_PERSO_MAIL,       FldTypVarChar.s_getInstance(), 20, _strPersonnelMail_);
        super.add(STR_TRAVAIL_MAIL,     FldTypVarChar.s_getInstance(), 20, _strTravailMail_);
        super.add(STR_PERSO_FIXE,       FldTypVarChar.s_getInstance(), 20, _strPersonnelFixe_);
        super.add(STR_TRAVAIL_FIXE,     FldTypVarChar.s_getInstance(), 20, _strTravailFixe_);
        super.add(STR_PERSO_PORTABLE,   FldTypVarChar.s_getInstance(), 20, _strPersonnelPortable_);
        super.add(STR_TRAVAIL_PORTABLE, FldTypVarChar.s_getInstance(), 20, _strTravailPortable_);
        super.add(STR_ADR_VOIE,         FldTypVarChar.s_getInstance(), 20, _strAdresseVoie_);
        super.add(STR_ADR_NUMERO,       FldTypVarChar.s_getInstance(), 4, _strAdresseNumero_);
        super.add(STR_ADR_LIGNE1,       FldTypVarChar.s_getInstance(), 20, _strAdresseLigne1_);
        super.add(STR_ADR_LIGNE2,       FldTypVarChar.s_getInstance(), 20, _strAdresseLigne2_);
        super.add(STR_ADR_CODE,         FldTypChar.s_getInstance(), 5, _strAdresseCode_);
        super.add(STR_ADR_VILLE,        FldTypVarChar.s_getInstance(), 20, _strAdresseVille_);
        super.add(STR_ADR_PAYS,         FldTypVarChar.s_getInstance(), 20, _strAdressePays_);
    }

    public static synchronized TblClt s_getInstance() {
        if (_INSTANCE_ == null) {
                _INSTANCE_ = new TblClt();
        }
        return _INSTANCE_;
    }


    final public static String STR_ID = "id";
    final public static String STR_IDT_NOM = "nom";
    final public static String STR_IDT_PRENOM1 = "prenom1";
    final public static String STR_IDT_PRENOM2 = "prenom2";
    final public static String STR_IDT_PRENOM3 = "prenom3";
    final public static String STR_IDT_BIRTH = "dateNaissance";
    final public static String STR_IDT_SEXE = "sexe";
    final public static String STR_ADR_NUMERO = "numeroDeRue";
    final public static String STR_ADR_VOIE = "nomRue";
    final public static String STR_ADR_LIGNE1 = "ligneCourrier1";
    final public static String STR_ADR_LIGNE2 = "ligneCourrier2";
    final public static String STR_ADR_CODE = "codePostal";
    final public static String STR_ADR_VILLE = "ville";
    final public static String STR_ADR_PAYS = "pays";
    final public static String STR_LOGIN = "login";
    final public static String STR_PASSWORD = "password";
    final public static String STR_TRAVAIL_MAIL = "adresseEmailTravail";
    final public static String STR_TRAVAIL_FIXE = "telTravail";
    final public static String STR_TRAVAIL_PORTABLE = "portableTravail";
    final public static String STR_PERSO_MAIL = "adresseEmailPerso";
    final public static String STR_PERSO_FIXE = "telPerso";
    final public static String STR_PERSO_PORTABLE = "portablePerso";

    
    private static TblClt _INSTANCE_;
    private String _strId_;
    private String _strIdentiteNom_;
    private String _strIdentitePrenom1_;
    private String _strIdentitePrenom2_;
    private String _strIdentitePrenom3_;
    private String _strAdresseNumero_;
    private String _strAdresseVoie_;
    private String _strAdresseLigne1_;
    private String _strAdresseLigne2_;
    private String _strAdresseCode_;
    private String _strAdresseVille_;
    private String _strAdressePays_;
    private String _strTravailMail_;
    private String _strTravailFixe_;
    private String _strTravailPortable_;
    private String _strPersonnelMail_;
    private String _strPersonnelFixe_;
    private String _strPersonnelPortable_;
    private String _strIdentiteDateNaissance_;
    private String _strIdentiteSexe_;
}
